Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 100000 |
| Missing cells | 95887 |
| Missing cells (%) | 5.0% |
| Duplicate rows | 10215 |
| Duplicate rows (%) | 10.2% |
| Total size in memory | 14.5 MiB |
| Average record size in memory | 152.0 B |
Variable types
| Categorical | 7 |
|---|---|
| Numeric | 12 |
| Dataset has 10215 (10.2%) duplicate rows | Duplicates |
Loan ID has a high cardinality: 81999 distinct values | High cardinality |
Customer ID has a high cardinality: 81999 distinct values | High cardinality |
Annual Income is highly correlated with Monthly Debt | High correlation |
Monthly Debt is highly correlated with Current Credit Balance | High correlation |
Number of Credit Problems is highly correlated with Bankruptcies and 1 other fields | High correlation |
Current Credit Balance is highly correlated with Monthly Debt | High correlation |
Maximum Open Credit is highly correlated with Current Credit Balance | High correlation |
Bankruptcies is highly correlated with Number of Credit Problems | High correlation |
Tax Liens is highly correlated with Number of Credit Problems | High correlation |
Loan Status is highly correlated with Credit Score | High correlation |
Credit Score is highly correlated with Loan Status | High correlation |
Home Ownership is highly correlated with Purpose | High correlation |
Purpose is highly correlated with Home Ownership | High correlation |
Credit Score has 19154 (19.2%) missing values | Missing |
Annual Income has 19154 (19.2%) missing values | Missing |
Years in current job has 4222 (4.2%) missing values | Missing |
Months since last delinquent has 53141 (53.1%) missing values | Missing |
Annual Income is highly skewed (γ1 = 46.88869873) | Skewed |
Maximum Open Credit is highly skewed (γ1 = 132.6388749) | Skewed |
Loan ID is uniformly distributed | Uniform |
Customer ID is uniformly distributed | Uniform |
Number of Credit Problems has 86035 (86.0%) zeros | Zeros |
Bankruptcies has 88774 (88.8%) zeros | Zeros |
Tax Liens has 98062 (98.1%) zeros | Zeros |
Reproduction
| Analysis started | 2022-12-15 10:05:10.108191 |
|---|---|
| Analysis finished | 2022-12-15 10:05:28.182106 |
| Duration | 18.07 seconds |
| Software version | pandas-profiling v3.3.0 |
| Download configuration | config.json |
| Distinct | 81999 |
|---|---|
| Distinct (%) | 82.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| 14dd8831-6af5-400b-83ec-68e61888a048 | 2 |
|---|---|
| 1373bfdf-ae6d-4fa5-b3e9-73ba60b7868e | 2 |
| 111602d9-f958-403d-a9d5-4fba630297eb | 2 |
| 1076b681-b8ff-463f-a7af-576e12edd637 | 2 |
| f7817002-4e22-4462-8abc-402eb4ceaa6c | 2 |
| Other values (81994) |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 3600000 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 63998 ? |
|---|---|
| Unique (%) | 64.0% |
Sample
| 1st row | 14dd8831-6af5-400b-83ec-68e61888a048 |
|---|---|
| 2nd row | 4771cc26-131a-45db-b5aa-537ea4ba5342 |
| 3rd row | 4eed4e6a-aa2f-4c91-8651-ce984ee8fb26 |
| 4th row | 77598f7b-32e7-4e3b-a6e5-06ba0d98fe8a |
| 5th row | d4062e70-befa-4995-8643-a0de73938182 |
Common Values
| Value | Count | Frequency (%) |
| 14dd8831-6af5-400b-83ec-68e61888a048 | 2 | < 0.1% |
| 1373bfdf-ae6d-4fa5-b3e9-73ba60b7868e | 2 | < 0.1% |
| 111602d9-f958-403d-a9d5-4fba630297eb | 2 | < 0.1% |
| 1076b681-b8ff-463f-a7af-576e12edd637 | 2 | < 0.1% |
| f7817002-4e22-4462-8abc-402eb4ceaa6c | 2 | < 0.1% |
| cbad155d-99e3-4cb5-b8ef-dc8ad694488c | 2 | < 0.1% |
| d9add07d-0988-4f3d-838d-a42a4fbd05ce | 2 | < 0.1% |
| 96638bcb-d939-41b0-9bb5-d951d6a4dcc2 | 2 | < 0.1% |
| 52d510dd-c367-4472-b450-125bb66f3288 | 2 | < 0.1% |
| 1c6d8406-97bb-416d-a416-701afb398983 | 2 | < 0.1% |
| Other values (81989) | 99980 |
Length
| Value | Count | Frequency (%) |
| 14dd8831-6af5-400b-83ec-68e61888a048 | 2 | < 0.1% |
| 4795c1ce-0d77-400a-b370-0ffc7b688a0d | 2 | < 0.1% |
| 1585509a-1a31-4460-949f-2624ed054176 | 2 | < 0.1% |
| 4c6d5ca9-b4f7-4724-b60d-4c39919f33dd | 2 | < 0.1% |
| 070efe1e-7911-4927-b466-e7541fc557a3 | 2 | < 0.1% |
| 6eb14cde-2de6-48df-a6dc-72527642d105 | 2 | < 0.1% |
| e8f5ca19-f3f7-487f-aba7-26c0b600a7a3 | 2 | < 0.1% |
| c9488ac4-87ed-4da7-bdda-194e7d828894 | 2 | < 0.1% |
| 9fe9322c-fb7b-4777-a763-a6ec220e4d53 | 2 | < 0.1% |
| 95533358-c862-4fdb-9ca9-0b2124209247 | 2 | < 0.1% |
| Other values (81989) | 99980 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 400000 | 11.1% |
| 4 | 287551 | 8.0% |
| a | 212644 | 5.9% |
| 9 | 212346 | 5.9% |
| b | 211946 | 5.9% |
| 8 | 211864 | 5.9% |
| 0 | 188172 | 5.2% |
| 2 | 188148 | 5.2% |
| c | 188078 | 5.2% |
| 7 | 187813 | 5.2% |
| Other values (7) | 1311438 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2025282 | |
| Lowercase Letter | 1174718 | |
| Dash Punctuation | 400000 | 11.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 287551 | |
| 9 | 212346 | |
| 8 | 211864 | |
| 0 | 188172 | |
| 2 | 188148 | |
| 7 | 187813 | |
| 1 | 187606 | |
| 5 | 187480 | |
| 3 | 187225 | |
| 6 | 187077 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 212644 | |
| b | 211946 | |
| c | 188078 | |
| e | 187476 | |
| d | 187374 | |
| f | 187200 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 400000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2425282 | |
| Latin | 1174718 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| - | 400000 | |
| 4 | 287551 | |
| 9 | 212346 | |
| 8 | 211864 | |
| 0 | 188172 | |
| 2 | 188148 | |
| 7 | 187813 | |
| 1 | 187606 | |
| 5 | 187480 | |
| 3 | 187225 |
Latin
| Value | Count | Frequency (%) |
| a | 212644 | |
| b | 211946 | |
| c | 188078 | |
| e | 187476 | |
| d | 187374 | |
| f | 187200 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3600000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 400000 | 11.1% |
| 4 | 287551 | 8.0% |
| a | 212644 | 5.9% |
| 9 | 212346 | 5.9% |
| b | 211946 | 5.9% |
| 8 | 211864 | 5.9% |
| 0 | 188172 | 5.2% |
| 2 | 188148 | 5.2% |
| c | 188078 | 5.2% |
| 7 | 187813 | 5.2% |
| Other values (7) | 1311438 |
| Distinct | 81999 |
|---|---|
| Distinct (%) | 82.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| 981165ec-3274-42f5-a3b4-d104041a9ca9 | 2 |
|---|---|
| 3b5f11f9-0951-43e2-bed5-d24d1e4e8b76 | 2 |
| add9dac6-c1ad-4441-ba96-274fbf493379 | 2 |
| 7bc16148-ec0a-4b75-89fc-20ca13350175 | 2 |
| 3b561060-1b20-4c36-95c2-9a9b1bf54195 | 2 |
| Other values (81994) |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 3600000 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 63998 ? |
|---|---|
| Unique (%) | 64.0% |
Sample
| 1st row | 981165ec-3274-42f5-a3b4-d104041a9ca9 |
|---|---|
| 2nd row | 2de017a3-2e01-49cb-a581-08169e83be29 |
| 3rd row | 5efb2b2b-bf11-4dfd-a572-3761a2694725 |
| 4th row | e777faab-98ae-45af-9a86-7ce5b33b1011 |
| 5th row | 81536ad9-5ccf-4eb8-befb-47a4d608658e |
Common Values
| Value | Count | Frequency (%) |
| 981165ec-3274-42f5-a3b4-d104041a9ca9 | 2 | < 0.1% |
| 3b5f11f9-0951-43e2-bed5-d24d1e4e8b76 | 2 | < 0.1% |
| add9dac6-c1ad-4441-ba96-274fbf493379 | 2 | < 0.1% |
| 7bc16148-ec0a-4b75-89fc-20ca13350175 | 2 | < 0.1% |
| 3b561060-1b20-4c36-95c2-9a9b1bf54195 | 2 | < 0.1% |
| f4eed63c-0c95-4ffa-bf31-585c73ff3f91 | 2 | < 0.1% |
| a42ab3d2-db8b-4d20-a357-f26c7a6f10b5 | 2 | < 0.1% |
| 5c5731e6-64da-4e40-a0d2-f858957263ae | 2 | < 0.1% |
| 9606e990-2ab6-4e5d-ba59-a4cf61254b48 | 2 | < 0.1% |
| 6a03d0e7-5d8d-4399-a944-236f40224d31 | 2 | < 0.1% |
| Other values (81989) | 99980 |
Length
| Value | Count | Frequency (%) |
| 981165ec-3274-42f5-a3b4-d104041a9ca9 | 2 | < 0.1% |
| 02a9a103-ce6d-4d24-ad1d-1e68074a0e75 | 2 | < 0.1% |
| 6d13a492-d15a-4f16-9785-4751d947bf64 | 2 | < 0.1% |
| 89a9a394-95eb-46e0-aabc-d1dd39dbbc25 | 2 | < 0.1% |
| 9cf7c200-a608-4404-883a-17964f19e3c3 | 2 | < 0.1% |
| 260c52a3-46b8-4cdc-89e7-352960557344 | 2 | < 0.1% |
| 69f7f1af-4464-4d8b-8c41-17d15b7b5e4d | 2 | < 0.1% |
| 123b0aba-90c7-4d67-9d17-d8566fd91e74 | 2 | < 0.1% |
| f1cb42a4-a25d-4cc6-8cdf-94c147ec9906 | 2 | < 0.1% |
| eeb8789e-5124-4854-9aab-7aa178d0f82e | 2 | < 0.1% |
| Other values (81989) | 99980 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 400000 | 11.1% |
| 4 | 287889 | 8.0% |
| a | 212705 | 5.9% |
| 8 | 212170 | 5.9% |
| b | 211850 | 5.9% |
| 9 | 211791 | 5.9% |
| c | 188049 | 5.2% |
| e | 188024 | 5.2% |
| 7 | 187963 | 5.2% |
| 5 | 187790 | 5.2% |
| Other values (7) | 1311769 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2024943 | |
| Lowercase Letter | 1175057 | |
| Dash Punctuation | 400000 | 11.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 287889 | |
| 8 | 212170 | |
| 9 | 211791 | |
| 7 | 187963 | |
| 5 | 187790 | |
| 6 | 187624 | |
| 3 | 187601 | |
| 1 | 187434 | |
| 0 | 187400 | |
| 2 | 187281 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 212705 | |
| b | 211850 | |
| c | 188049 | |
| e | 188024 | |
| d | 187287 | |
| f | 187142 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 400000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2424943 | |
| Latin | 1175057 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| - | 400000 | |
| 4 | 287889 | |
| 8 | 212170 | |
| 9 | 211791 | |
| 7 | 187963 | |
| 5 | 187790 | |
| 6 | 187624 | |
| 3 | 187601 | |
| 1 | 187434 | |
| 0 | 187400 |
Latin
| Value | Count | Frequency (%) |
| a | 212705 | |
| b | 211850 | |
| c | 188049 | |
| e | 188024 | |
| d | 187287 | |
| f | 187142 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3600000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 400000 | 11.1% |
| 4 | 287889 | 8.0% |
| a | 212705 | 5.9% |
| 8 | 212170 | 5.9% |
| b | 211850 | 5.9% |
| 9 | 211791 | 5.9% |
| c | 188049 | 5.2% |
| e | 188024 | 5.2% |
| 7 | 187963 | 5.2% |
| 5 | 187790 | 5.2% |
| Other values (7) | 1311769 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| Fully Paid | |
|---|---|
| Charged Off |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 10.22639 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1022639 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fully Paid |
|---|---|
| 2nd row | Fully Paid |
| 3rd row | Fully Paid |
| 4th row | Fully Paid |
| 5th row | Fully Paid |
Common Values
| Value | Count | Frequency (%) |
| Fully Paid | 77361 | |
| Charged Off | 22639 | 22.6% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| fully | 77361 | |
| paid | 77361 | |
| charged | 22639 | 11.3% |
| off | 22639 | 11.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 154722 | |
| 100000 | ||
| a | 100000 | |
| d | 100000 | |
| F | 77361 | |
| u | 77361 | |
| y | 77361 | |
| P | 77361 | |
| i | 77361 | |
| f | 45278 | 4.4% |
| Other values (6) | 135834 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 722639 | |
| Uppercase Letter | 200000 | 19.6% |
| Space Separator | 100000 | 9.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 154722 | |
| a | 100000 | |
| d | 100000 | |
| u | 77361 | |
| y | 77361 | |
| i | 77361 | |
| f | 45278 | 6.3% |
| h | 22639 | 3.1% |
| r | 22639 | 3.1% |
| g | 22639 | 3.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 77361 | |
| P | 77361 | |
| C | 22639 | 11.3% |
| O | 22639 | 11.3% |
Space Separator
| Value | Count | Frequency (%) |
| 100000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 922639 | |
| Common | 100000 | 9.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 154722 | |
| a | 100000 | |
| d | 100000 | |
| F | 77361 | |
| u | 77361 | |
| y | 77361 | |
| P | 77361 | |
| i | 77361 | |
| f | 45278 | 4.9% |
| C | 22639 | 2.5% |
| Other values (5) | 113195 |
Common
| Value | Count | Frequency (%) |
| 100000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1022639 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 154722 | |
| 100000 | ||
| a | 100000 | |
| d | 100000 | |
| F | 77361 | |
| u | 77361 | |
| y | 77361 | |
| P | 77361 | |
| i | 77361 | |
| f | 45278 | 4.4% |
| Other values (6) | 135834 |
Current Loan Amount
Real number (ℝ≥0)
| Distinct | 22004 |
|---|---|
| Distinct (%) | 22.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11760447.39 |
| Minimum | 10802 |
|---|---|
| Maximum | 99999999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 10802 |
|---|---|
| 5-th percentile | 76054 |
| Q1 | 179652 |
| median | 312246 |
| Q3 | 524942 |
| 95-th percentile | 99999999 |
| Maximum | 99999999 |
| Range | 99989197 |
| Interquartile range (IQR) | 345290 |
Descriptive statistics
| Standard deviation | 31783942.55 |
|---|---|
| Coefficient of variation (CV) | 2.702613387 |
| Kurtosis | 3.837366224 |
| Mean | 11760447.39 |
| Median Absolute Deviation (MAD) | 147664 |
| Skewness | 2.415986608 |
| Sum | 1.176044739 × 1012 |
| Variance | 1.010219004 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99999999 | 11484 | 11.5% |
| 223102 | 27 | < 0.1% |
| 223322 | 27 | < 0.1% |
| 216194 | 27 | < 0.1% |
| 223652 | 27 | < 0.1% |
| 108966 | 26 | < 0.1% |
| 222596 | 26 | < 0.1% |
| 214962 | 25 | < 0.1% |
| 216810 | 25 | < 0.1% |
| 179828 | 25 | < 0.1% |
| Other values (21994) | 88281 |
| Value | Count | Frequency (%) |
| 10802 | 1 | < 0.1% |
| 11242 | 1 | < 0.1% |
| 15422 | 2 | < 0.1% |
| 21098 | 1 | < 0.1% |
| 21450 | 3 | < 0.1% |
| 21472 | 9 | |
| 21494 | 3 | < 0.1% |
| 21516 | 6 | |
| 21538 | 7 | |
| 21560 | 4 |
| Value | Count | Frequency (%) |
| 99999999 | 11484 | |
| 789250 | 3 | < 0.1% |
| 789184 | 6 | < 0.1% |
| 789096 | 16 | < 0.1% |
| 789030 | 9 | < 0.1% |
| 788942 | 9 | < 0.1% |
| 788876 | 4 | < 0.1% |
| 788788 | 5 | < 0.1% |
| 788722 | 2 | < 0.1% |
| 788634 | 8 | < 0.1% |
Term
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| Short Term | |
|---|---|
| Long Term |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.72208 |
| Min length | 9 |
Characters and Unicode
| Total characters | 972208 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Short Term |
|---|---|
| 2nd row | Short Term |
| 3rd row | Short Term |
| 4th row | Long Term |
| 5th row | Short Term |
Common Values
| Value | Count | Frequency (%) |
| Short Term | 72208 | |
| Long Term | 27792 | 27.8% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| term | 100000 | |
| short | 72208 | |
| long | 27792 | 13.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 172208 | |
| o | 100000 | |
| 100000 | ||
| T | 100000 | |
| e | 100000 | |
| m | 100000 | |
| S | 72208 | |
| h | 72208 | |
| t | 72208 | |
| L | 27792 | 2.9% |
| Other values (2) | 55584 | 5.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 672208 | |
| Uppercase Letter | 200000 | 20.6% |
| Space Separator | 100000 | 10.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 172208 | |
| o | 100000 | |
| e | 100000 | |
| m | 100000 | |
| h | 72208 | |
| t | 72208 | |
| n | 27792 | 4.1% |
| g | 27792 | 4.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 100000 | |
| S | 72208 | |
| L | 27792 | 13.9% |
Space Separator
| Value | Count | Frequency (%) |
| 100000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 872208 | |
| Common | 100000 | 10.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 172208 | |
| o | 100000 | |
| T | 100000 | |
| e | 100000 | |
| m | 100000 | |
| S | 72208 | |
| h | 72208 | |
| t | 72208 | |
| L | 27792 | 3.2% |
| n | 27792 | 3.2% |
Common
| Value | Count | Frequency (%) |
| 100000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 972208 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 172208 | |
| o | 100000 | |
| 100000 | ||
| T | 100000 | |
| e | 100000 | |
| m | 100000 | |
| S | 72208 | |
| h | 72208 | |
| t | 72208 | |
| L | 27792 | 2.9% |
| Other values (2) | 55584 | 5.7% |
| Distinct | 324 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 19154 |
| Missing (%) | 19.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1076.456089 |
| Minimum | 585 |
|---|---|
| Maximum | 7510 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 585 |
|---|---|
| 5-th percentile | 661 |
| Q1 | 705 |
| median | 724 |
| Q3 | 741 |
| 95-th percentile | 6690 |
| Maximum | 7510 |
| Range | 6925 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 1475.403791 |
|---|---|
| Coefficient of variation (CV) | 1.370612147 |
| Kurtosis | 12.97183192 |
| Mean | 1076.456089 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 3.86322527 |
| Sum | 87027169 |
| Variance | 2176816.348 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 747 | 1825 | 1.8% |
| 740 | 1746 | 1.7% |
| 746 | 1742 | 1.7% |
| 741 | 1732 | 1.7% |
| 742 | 1723 | 1.7% |
| 739 | 1624 | 1.6% |
| 745 | 1612 | 1.6% |
| 748 | 1598 | 1.6% |
| 743 | 1555 | 1.6% |
| 725 | 1548 | 1.5% |
| Other values (314) | 64141 | |
| (Missing) | 19154 | 19.2% |
| Value | Count | Frequency (%) |
| 585 | 12 | |
| 586 | 7 | < 0.1% |
| 587 | 11 | |
| 588 | 20 | |
| 589 | 6 | < 0.1% |
| 590 | 8 | < 0.1% |
| 591 | 9 | |
| 592 | 4 | < 0.1% |
| 593 | 7 | < 0.1% |
| 594 | 10 |
| Value | Count | Frequency (%) |
| 7510 | 9 | < 0.1% |
| 7500 | 24 | < 0.1% |
| 7490 | 23 | < 0.1% |
| 7480 | 43 | |
| 7470 | 51 | |
| 7460 | 76 | |
| 7450 | 55 | |
| 7440 | 58 | |
| 7430 | 70 | |
| 7420 | 84 |
| Distinct | 36174 |
|---|---|
| Distinct (%) | 44.7% |
| Missing | 19154 |
| Missing (%) | 19.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1378276.56 |
| Minimum | 76627 |
|---|---|
| Maximum | 165557393 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 76627 |
|---|---|
| 5-th percentile | 519863.75 |
| Q1 | 848844 |
| median | 1174162 |
| Q3 | 1650663 |
| 95-th percentile | 2810579.75 |
| Maximum | 165557393 |
| Range | 165480766 |
| Interquartile range (IQR) | 801819 |
Descriptive statistics
| Standard deviation | 1081360.196 |
|---|---|
| Coefficient of variation (CV) | 0.7845741756 |
| Kurtosis | 6624.167709 |
| Mean | 1378276.56 |
| Median Absolute Deviation (MAD) | 380703 |
| Skewness | 46.88869873 |
| Sum | 1.114281468 × 1011 |
| Variance | 1.169339873 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1162572 | 22 | < 0.1% |
| 973370 | 19 | < 0.1% |
| 969475 | 18 | < 0.1% |
| 1140000 | 18 | < 0.1% |
| 1143762 | 17 | < 0.1% |
| 949905 | 17 | < 0.1% |
| 1112640 | 17 | < 0.1% |
| 953230 | 17 | < 0.1% |
| 1320291 | 17 | < 0.1% |
| 1166220 | 17 | < 0.1% |
| Other values (36164) | 80667 | |
| (Missing) | 19154 | 19.2% |
| Value | Count | Frequency (%) |
| 76627 | 1 | |
| 81092 | 1 | |
| 94867 | 1 | |
| 97033 | 1 | |
| 106533 | 1 | |
| 111245 | 2 | |
| 130150 | 1 | |
| 134881 | 2 | |
| 135071 | 2 | |
| 144267 | 2 |
| Value | Count | Frequency (%) |
| 165557393 | 1 | |
| 36475440 | 1 | |
| 30838995 | 1 | |
| 28095300 | 1 | |
| 24161540 | 1 | |
| 23980375 | 1 | |
| 22448880 | 2 | |
| 19019000 | 1 | |
| 18768200 | 2 | |
| 18743937 | 1 |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4222 |
| Missing (%) | 4.2% |
| Memory size | 781.4 KiB |
| 10+ years | |
|---|---|
| 2 years | |
| 3 years | |
| < 1 year | |
| 5 years | |
| Other values (6) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.667648103 |
| Min length | 6 |
Characters and Unicode
| Total characters | 734392 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 8 years |
|---|---|
| 2nd row | 10+ years |
| 3rd row | 8 years |
| 4th row | 3 years |
| 5th row | 5 years |
Common Values
| Value | Count | Frequency (%) |
| 10+ years | 31121 | |
| 2 years | 9134 | 9.1% |
| 3 years | 8169 | 8.2% |
| < 1 year | 8164 | 8.2% |
| 5 years | 6787 | 6.8% |
| 1 year | 6460 | 6.5% |
| 4 years | 6143 | 6.1% |
| 6 years | 5686 | 5.7% |
| 7 years | 5577 | 5.6% |
| 8 years | 4582 | 4.6% |
| (Missing) | 4222 | 4.2% |
Length
| Value | Count | Frequency (%) |
| years | 81154 | |
| 10 | 31121 | 15.6% |
| 1 | 14624 | 7.3% |
| year | 14624 | 7.3% |
| 2 | 9134 | 4.6% |
| 3 | 8169 | 4.1% |
| 8164 | 4.1% | |
| 5 | 6787 | 3.4% |
| 4 | 6143 | 3.1% |
| 6 | 5686 | 2.8% |
| Other values (3) | 14114 | 7.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 103942 | ||
| y | 95778 | |
| e | 95778 | |
| a | 95778 | |
| r | 95778 | |
| s | 81154 | |
| 1 | 45745 | |
| 0 | 31121 | 4.2% |
| + | 31121 | 4.2% |
| 2 | 9134 | 1.2% |
| Other values (8) | 49063 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 464266 | |
| Decimal Number | 126899 | 17.3% |
| Space Separator | 103942 | 14.2% |
| Math Symbol | 39285 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 45745 | |
| 0 | 31121 | |
| 2 | 9134 | 7.2% |
| 3 | 8169 | 6.4% |
| 5 | 6787 | 5.3% |
| 4 | 6143 | 4.8% |
| 6 | 5686 | 4.5% |
| 7 | 5577 | 4.4% |
| 8 | 4582 | 3.6% |
| 9 | 3955 | 3.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| y | 95778 | |
| e | 95778 | |
| a | 95778 | |
| r | 95778 | |
| s | 81154 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 31121 | |
| < | 8164 | 20.8% |
Space Separator
| Value | Count | Frequency (%) |
| 103942 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 464266 | |
| Common | 270126 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 103942 | ||
| 1 | 45745 | |
| 0 | 31121 | 11.5% |
| + | 31121 | 11.5% |
| 2 | 9134 | 3.4% |
| 3 | 8169 | 3.0% |
| < | 8164 | 3.0% |
| 5 | 6787 | 2.5% |
| 4 | 6143 | 2.3% |
| 6 | 5686 | 2.1% |
| Other values (3) | 14114 | 5.2% |
Latin
| Value | Count | Frequency (%) |
| y | 95778 | |
| e | 95778 | |
| a | 95778 | |
| r | 95778 | |
| s | 81154 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 734392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 103942 | ||
| y | 95778 | |
| e | 95778 | |
| a | 95778 | |
| r | 95778 | |
| s | 81154 | |
| 1 | 45745 | |
| 0 | 31121 | 4.2% |
| + | 31121 | 4.2% |
| 2 | 9134 | 1.2% |
| Other values (8) | 49063 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| Home Mortgage | |
|---|---|
| Rent | |
| Own Home | |
| HaveMortgage | 214 |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 8.7413 |
| Min length | 4 |
Characters and Unicode
| Total characters | 874130 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Home Mortgage |
|---|---|
| 2nd row | Home Mortgage |
| 3rd row | Own Home |
| 4th row | Own Home |
| 5th row | Rent |
Common Values
| Value | Count | Frequency (%) |
| Home Mortgage | 48410 | |
| Rent | 42194 | |
| Own Home | 9182 | 9.2% |
| HaveMortgage | 214 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| home | 57592 | |
| mortgage | 48410 | |
| rent | 42194 | |
| own | 9182 | 5.8% |
| havemortgage | 214 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 148624 | |
| o | 106216 | |
| g | 97248 | |
| t | 90818 | |
| H | 57806 | 6.6% |
| m | 57592 | 6.6% |
| 57592 | 6.6% | |
| n | 51376 | 5.9% |
| a | 48838 | 5.6% |
| M | 48624 | 5.6% |
| Other values (5) | 109396 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 658732 | |
| Uppercase Letter | 157806 | 18.1% |
| Space Separator | 57592 | 6.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 148624 | |
| o | 106216 | |
| g | 97248 | |
| t | 90818 | |
| m | 57592 | 8.7% |
| n | 51376 | 7.8% |
| a | 48838 | 7.4% |
| r | 48624 | 7.4% |
| w | 9182 | 1.4% |
| v | 214 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 57806 | |
| M | 48624 | |
| R | 42194 | |
| O | 9182 | 5.8% |
Space Separator
| Value | Count | Frequency (%) |
| 57592 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 816538 | |
| Common | 57592 | 6.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 148624 | |
| o | 106216 | |
| g | 97248 | |
| t | 90818 | |
| H | 57806 | 7.1% |
| m | 57592 | 7.1% |
| n | 51376 | 6.3% |
| a | 48838 | 6.0% |
| M | 48624 | 6.0% |
| r | 48624 | 6.0% |
| Other values (4) | 60772 |
Common
| Value | Count | Frequency (%) |
| 57592 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 874130 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 148624 | |
| o | 106216 | |
| g | 97248 | |
| t | 90818 | |
| H | 57806 | 6.6% |
| m | 57592 | 6.6% |
| 57592 | 6.6% | |
| n | 51376 | 5.9% |
| a | 48838 | 5.6% |
| M | 48624 | 5.6% |
| Other values (5) | 109396 |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.4 KiB |
| Debt Consolidation | |
|---|---|
| other | 6037 |
| Home Improvements | 5839 |
| Other | 3250 |
| Business Loan | 1569 |
| Other values (11) | 4753 |
Length
| Max length | 20 |
|---|---|
| Median length | 18 |
| Mean length | 16.32015 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1632015 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Home Improvements |
|---|---|
| 2nd row | Debt Consolidation |
| 3rd row | Debt Consolidation |
| 4th row | Debt Consolidation |
| 5th row | Debt Consolidation |
Common Values
| Value | Count | Frequency (%) |
| Debt Consolidation | 78552 | |
| other | 6037 | 6.0% |
| Home Improvements | 5839 | 5.8% |
| Other | 3250 | 3.2% |
| Business Loan | 1569 | 1.6% |
| Buy a Car | 1265 | 1.3% |
| Medical Bills | 1127 | 1.1% |
| Buy House | 678 | 0.7% |
| Take a Trip | 573 | 0.6% |
| major_purchase | 352 | 0.4% |
| Other values (6) | 758 | 0.8% |
Length
| Value | Count | Frequency (%) |
| debt | 78552 | |
| consolidation | 78552 | |
| other | 9287 | 4.8% |
| home | 5839 | 3.0% |
| improvements | 5839 | 3.0% |
| buy | 1943 | 1.0% |
| a | 1838 | 1.0% |
| business | 1569 | 0.8% |
| loan | 1569 | 0.8% |
| car | 1265 | 0.7% |
| Other values (13) | 5287 | 2.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 256320 | |
| t | 172430 | |
| n | 166948 | |
| i | 162248 | |
| e | 110301 | 6.8% |
| s | 92585 | 5.7% |
| 91540 | 5.6% | |
| a | 86321 | 5.3% |
| l | 82608 | 5.1% |
| d | 80008 | 4.9% |
| Other values (25) | 330706 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1357176 | |
| Uppercase Letter | 182654 | 11.2% |
| Space Separator | 91540 | 5.6% |
| Connector Punctuation | 645 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 256320 | |
| t | 172430 | |
| n | 166948 | |
| i | 162248 | |
| e | 110301 | |
| s | 92585 | 6.8% |
| a | 86321 | 6.4% |
| l | 82608 | 6.1% |
| d | 80008 | 5.9% |
| b | 78845 | 5.8% |
| Other values (13) | 68562 | 5.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 79817 | |
| D | 78552 | |
| H | 6517 | 3.6% |
| I | 5839 | 3.2% |
| B | 4639 | 2.5% |
| O | 3250 | 1.8% |
| L | 1569 | 0.9% |
| T | 1146 | 0.6% |
| M | 1127 | 0.6% |
| E | 198 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 91540 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 645 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1539830 | |
| Common | 92185 | 5.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 256320 | |
| t | 172430 | |
| n | 166948 | |
| i | 162248 | |
| e | 110301 | |
| s | 92585 | 6.0% |
| a | 86321 | 5.6% |
| l | 82608 | 5.4% |
| d | 80008 | 5.2% |
| C | 79817 | 5.2% |
| Other values (23) | 250244 |
Common
| Value | Count | Frequency (%) |
| 91540 | ||
| _ | 645 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1632015 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 256320 | |
| t | 172430 | |
| n | 166948 | |
| i | 162248 | |
| e | 110301 | 6.8% |
| s | 92585 | 5.7% |
| 91540 | 5.6% | |
| a | 86321 | 5.3% |
| l | 82608 | 5.1% |
| d | 80008 | 4.9% |
| Other values (25) | 330706 |
| Distinct | 65765 |
|---|---|
| Distinct (%) | 65.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18472.41234 |
| Minimum | 0 |
|---|---|
| Maximum | 435843.28 |
| Zeros | 74 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3714.823 |
| Q1 | 10214.1625 |
| median | 16220.3 |
| Q3 | 24012.0575 |
| 95-th percentile | 40477.6095 |
| Maximum | 435843.28 |
| Range | 435843.28 |
| Interquartile range (IQR) | 13797.895 |
Descriptive statistics
| Standard deviation | 12174.99261 |
|---|---|
| Coefficient of variation (CV) | 0.659090561 |
| Kurtosis | 22.19305843 |
| Mean | 18472.41234 |
| Median Absolute Deviation (MAD) | 6724.48 |
| Skewness | 2.213941648 |
| Sum | 1847241234 |
| Variance | 148230445 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 74 | 0.1% |
| 15903 | 9 | < 0.1% |
| 11162.88 | 9 | < 0.1% |
| 13033.43 | 8 | < 0.1% |
| 12656.47 | 8 | < 0.1% |
| 10647.98 | 8 | < 0.1% |
| 14726.52 | 8 | < 0.1% |
| 13359.85 | 8 | < 0.1% |
| 12967.5 | 8 | < 0.1% |
| 15343.07 | 8 | < 0.1% |
| Other values (65755) | 99852 |
| Value | Count | Frequency (%) |
| 0 | 74 | |
| 7.41 | 2 | < 0.1% |
| 12.92 | 1 | < 0.1% |
| 17.1 | 1 | < 0.1% |
| 19.57 | 1 | < 0.1% |
| 20.71 | 1 | < 0.1% |
| 22.23 | 1 | < 0.1% |
| 28.5 | 1 | < 0.1% |
| 34.96 | 2 | < 0.1% |
| 41.99 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 435843.28 | 1 | |
| 229057.92 | 1 | |
| 205801.35 | 1 | |
| 173265.56 | 2 | |
| 172156.15 | 1 | |
| 165810.53 | 1 | |
| 165437.18 | 2 | |
| 152512.24 | 1 | |
| 152331.93 | 1 | |
| 147152.53 | 1 |
Years of Credit History
Real number (ℝ≥0)
| Distinct | 506 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.199141 |
| Minimum | 3.6 |
|---|---|
| Maximum | 70.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 3.6 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 13.5 |
| median | 16.9 |
| Q3 | 21.7 |
| 95-th percentile | 31.7 |
| Maximum | 70.5 |
| Range | 66.9 |
| Interquartile range (IQR) | 8.2 |
Descriptive statistics
| Standard deviation | 7.01532365 |
|---|---|
| Coefficient of variation (CV) | 0.385475537 |
| Kurtosis | 1.740701905 |
| Mean | 18.199141 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.071550923 |
| Sum | 1819914.1 |
| Variance | 49.21476591 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 1340 | 1.3% |
| 15 | 1305 | 1.3% |
| 17 | 1219 | 1.2% |
| 16.5 | 1176 | 1.2% |
| 14 | 1151 | 1.2% |
| 15.4 | 1065 | 1.1% |
| 17.5 | 1025 | 1.0% |
| 13 | 1021 | 1.0% |
| 14.5 | 980 | 1.0% |
| 18 | 967 | 1.0% |
| Other values (496) | 88751 |
| Value | Count | Frequency (%) |
| 3.6 | 1 | < 0.1% |
| 3.7 | 2 | < 0.1% |
| 3.8 | 3 | < 0.1% |
| 3.9 | 4 | < 0.1% |
| 4 | 6 | < 0.1% |
| 4.1 | 8 | < 0.1% |
| 4.2 | 20 | |
| 4.3 | 9 | |
| 4.4 | 18 | |
| 4.5 | 17 |
| Value | Count | Frequency (%) |
| 70.5 | 1 | |
| 65 | 2 | |
| 60.5 | 2 | |
| 59.9 | 1 | |
| 59.7 | 1 | |
| 59.5 | 2 | |
| 58 | 1 | |
| 57.7 | 2 | |
| 57.5 | 1 | |
| 57 | 1 |
| Distinct | 116 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 53141 |
| Missing (%) | 53.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34.90132098 |
| Minimum | 0 |
|---|---|
| Maximum | 176 |
| Zeros | 216 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 32 |
| Q3 | 51 |
| 95-th percentile | 75 |
| Maximum | 176 |
| Range | 176 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 21.99782878 |
|---|---|
| Coefficient of variation (CV) | 0.6302864236 |
| Kurtosis | -0.7457896078 |
| Mean | 34.90132098 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 0.4343615565 |
| Sum | 1635441 |
| Variance | 483.9044711 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13 | 922 | 0.9% |
| 12 | 902 | 0.9% |
| 14 | 877 | 0.9% |
| 15 | 865 | 0.9% |
| 10 | 861 | 0.9% |
| 8 | 856 | 0.9% |
| 9 | 849 | 0.8% |
| 18 | 847 | 0.8% |
| 16 | 837 | 0.8% |
| 6 | 836 | 0.8% |
| Other values (106) | 38207 | |
| (Missing) | 53141 |
| Value | Count | Frequency (%) |
| 0 | 216 | 0.2% |
| 1 | 289 | 0.3% |
| 2 | 418 | |
| 3 | 445 | |
| 4 | 513 | |
| 5 | 703 | |
| 6 | 836 | |
| 7 | 825 | |
| 8 | 856 | |
| 9 | 849 |
| Value | Count | Frequency (%) |
| 176 | 2 | |
| 152 | 1 | |
| 148 | 1 | |
| 143 | 1 | |
| 141 | 1 | |
| 139 | 1 | |
| 131 | 1 | |
| 130 | 1 | |
| 129 | 1 | |
| 120 | 2 |
Number of Open Accounts
Real number (ℝ≥0)
| Distinct | 51 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.12853 |
| Minimum | 0 |
|---|---|
| Maximum | 76 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| median | 10 |
| Q3 | 14 |
| 95-th percentile | 20 |
| Maximum | 76 |
| Range | 76 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 5.00987036 |
|---|---|
| Coefficient of variation (CV) | 0.4501825812 |
| Kurtosis | 3.042766891 |
| Mean | 11.12853 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.17920132 |
| Sum | 1112853 |
| Variance | 25.09880103 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 9360 | 9.4% |
| 10 | 9012 | 9.0% |
| 8 | 8792 | 8.8% |
| 11 | 8601 | 8.6% |
| 7 | 8090 | 8.1% |
| 12 | 7461 | 7.5% |
| 6 | 6731 | 6.7% |
| 13 | 6280 | 6.3% |
| 14 | 5194 | 5.2% |
| 5 | 4742 | 4.7% |
| Other values (41) | 25737 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 1 | 25 | < 0.1% |
| 2 | 448 | 0.4% |
| 3 | 1364 | 1.4% |
| 4 | 2849 | 2.8% |
| 5 | 4742 | |
| 6 | 6731 | |
| 7 | 8090 | |
| 8 | 8792 | |
| 9 | 9360 |
| Value | Count | Frequency (%) |
| 76 | 2 | < 0.1% |
| 56 | 2 | < 0.1% |
| 52 | 2 | < 0.1% |
| 48 | 4 | < 0.1% |
| 47 | 3 | < 0.1% |
| 45 | 6 | |
| 44 | 5 | |
| 43 | 10 | |
| 42 | 5 | |
| 41 | 7 |
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.16831 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 86035 |
| Zeros (%) | 86.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4827049554 |
|---|---|
| Coefficient of variation (CV) | 2.867951728 |
| Kurtosis | 48.01246512 |
| Mean | 0.16831 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.823135609 |
| Sum | 16831 |
| Variance | 0.2330040739 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 86035 | |
| 1 | 12077 | 12.1% |
| 2 | 1299 | 1.3% |
| 3 | 378 | 0.4% |
| 4 | 125 | 0.1% |
| 5 | 49 | < 0.1% |
| 6 | 17 | < 0.1% |
| 7 | 8 | < 0.1% |
| 8 | 4 | < 0.1% |
| 11 | 2 | < 0.1% |
| Other values (4) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 86035 | |
| 1 | 12077 | 12.1% |
| 2 | 1299 | 1.3% |
| 3 | 378 | 0.4% |
| 4 | 125 | 0.1% |
| 5 | 49 | < 0.1% |
| 6 | 17 | < 0.1% |
| 7 | 8 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 7 | 8 | < 0.1% |
| 6 | 17 | < 0.1% |
| 5 | 49 | < 0.1% |
| 4 | 125 |
| Distinct | 32730 |
|---|---|
| Distinct (%) | 32.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 294637.3824 |
| Minimum | 0 |
|---|---|
| Maximum | 32878968 |
| Zeros | 572 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30400 |
| Q1 | 112670 |
| median | 209817 |
| Q3 | 367958.75 |
| 95-th percentile | 760741 |
| Maximum | 32878968 |
| Range | 32878968 |
| Interquartile range (IQR) | 255288.75 |
Descriptive statistics
| Standard deviation | 376170.9347 |
|---|---|
| Coefficient of variation (CV) | 1.276725077 |
| Kurtosis | 697.4981871 |
| Mean | 294637.3824 |
| Median Absolute Deviation (MAD) | 115007 |
| Skewness | 14.1544283 |
| Sum | 2.946373824 × 1010 |
| Variance | 1.415045721 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 572 | 0.6% |
| 67697 | 17 | < 0.1% |
| 175978 | 17 | < 0.1% |
| 65683 | 17 | < 0.1% |
| 124013 | 16 | < 0.1% |
| 246373 | 16 | < 0.1% |
| 88426 | 16 | < 0.1% |
| 100301 | 16 | < 0.1% |
| 148200 | 15 | < 0.1% |
| 111682 | 15 | < 0.1% |
| Other values (32720) | 99283 |
| Value | Count | Frequency (%) |
| 0 | 572 | |
| 19 | 12 | < 0.1% |
| 38 | 9 | < 0.1% |
| 57 | 7 | < 0.1% |
| 76 | 4 | < 0.1% |
| 95 | 6 | < 0.1% |
| 114 | 7 | < 0.1% |
| 133 | 5 | < 0.1% |
| 152 | 2 | < 0.1% |
| 171 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 32878968 | 1 | |
| 12986956 | 2 | |
| 12746397 | 2 | |
| 11796435 | 1 | |
| 11361924 | 1 | |
| 9134592 | 2 | |
| 7888952 | 1 | |
| 7749587 | 1 | |
| 7679344 | 1 | |
| 7666747 | 1 |
| Distinct | 44596 |
|---|---|
| Distinct (%) | 44.6% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 760798.3817 |
| Minimum | 0 |
|---|---|
| Maximum | 1539737892 |
| Zeros | 681 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 109758 |
| Q1 | 273438 |
| median | 467874 |
| Q3 | 782958 |
| 95-th percentile | 1640226.5 |
| Maximum | 1539737892 |
| Range | 1539737892 |
| Interquartile range (IQR) | 509520 |
Descriptive statistics
| Standard deviation | 8384503.472 |
|---|---|
| Coefficient of variation (CV) | 11.02066418 |
| Kurtosis | 20394.83985 |
| Mean | 760798.3817 |
| Median Absolute Deviation (MAD) | 230901 |
| Skewness | 132.6388749 |
| Sum | 7.607831658 × 1010 |
| Variance | 7.029989848 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 681 | 0.7% |
| 237204 | 13 | < 0.1% |
| 236412 | 12 | < 0.1% |
| 150194 | 12 | < 0.1% |
| 155474 | 12 | < 0.1% |
| 201652 | 12 | < 0.1% |
| 107404 | 12 | < 0.1% |
| 246136 | 12 | < 0.1% |
| 242968 | 12 | < 0.1% |
| 198088 | 11 | < 0.1% |
| Other values (44586) | 99209 |
| Value | Count | Frequency (%) |
| 0 | 681 | |
| 4334 | 4 | < 0.1% |
| 4444 | 1 | < 0.1% |
| 5390 | 1 | < 0.1% |
| 6446 | 5 | < 0.1% |
| 6468 | 3 | < 0.1% |
| 6490 | 2 | < 0.1% |
| 6512 | 2 | < 0.1% |
| 6534 | 1 | < 0.1% |
| 6556 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 1539737892 | 1 | |
| 1304726170 | 1 | |
| 980305260 | 1 | |
| 798255370 | 1 | |
| 632477736 | 1 | |
| 489343206 | 1 | |
| 380052288 | 1 | |
| 267490058 | 1 | |
| 265512874 | 1 | |
| 192284158 | 2 |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 204 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.11774019 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 88774 |
| Zeros (%) | 88.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3514238182 |
|---|---|
| Coefficient of variation (CV) | 2.98473969 |
| Kurtosis | 18.52767946 |
| Mean | 0.11774019 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.505803676 |
| Sum | 11750 |
| Variance | 0.1234987 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 88774 | |
| 1 | 10475 | 10.5% |
| 2 | 417 | 0.4% |
| 3 | 93 | 0.1% |
| 4 | 27 | < 0.1% |
| 5 | 7 | < 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| (Missing) | 204 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 88774 | |
| 1 | 10475 | 10.5% |
| 2 | 417 | 0.4% |
| 3 | 93 | 0.1% |
| 4 | 27 | < 0.1% |
| 5 | 7 | < 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 5 | 7 | < 0.1% |
| 4 | 27 | < 0.1% |
| 3 | 93 | 0.1% |
| 2 | 417 | 0.4% |
| 1 | 10475 | 10.5% |
| 0 | 88774 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02931293129 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 98062 |
| Zeros (%) | 98.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2581824362 |
|---|---|
| Coefficient of variation (CV) | 8.8078 |
| Kurtosis | 402.0666572 |
| Mean | 0.02931293129 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.50021981 |
| Sum | 2931 |
| Variance | 0.06665817038 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 98062 | |
| 1 | 1343 | 1.3% |
| 2 | 374 | 0.4% |
| 3 | 111 | 0.1% |
| 4 | 58 | 0.1% |
| 5 | 16 | < 0.1% |
| 6 | 12 | < 0.1% |
| 7 | 7 | < 0.1% |
| 9 | 3 | < 0.1% |
| 11 | 2 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
| (Missing) | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 98062 | |
| 1 | 1343 | 1.3% |
| 2 | 374 | 0.4% |
| 3 | 111 | 0.1% |
| 4 | 58 | 0.1% |
| 5 | 16 | < 0.1% |
| 6 | 12 | < 0.1% |
| 7 | 7 | < 0.1% |
| 9 | 3 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 7 | < 0.1% |
| 6 | 12 | < 0.1% |
| 5 | 16 | < 0.1% |
| 4 | 58 | 0.1% |
| 3 | 111 | 0.1% |
| 2 | 374 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Loan ID | Customer ID | Loan Status | Current Loan Amount | Term | Credit Score | Annual Income | Years in current job | Home Ownership | Purpose | Monthly Debt | Years of Credit History | Months since last delinquent | Number of Open Accounts | Number of Credit Problems | Current Credit Balance | Maximum Open Credit | Bankruptcies | Tax Liens | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 14dd8831-6af5-400b-83ec-68e61888a048 | 981165ec-3274-42f5-a3b4-d104041a9ca9 | Fully Paid | 445412 | Short Term | 709.0 | 1167493.0 | 8 years | Home Mortgage | Home Improvements | 5214.74 | 17.2 | NaN | 6 | 1 | 228190 | 416746.0 | 1.0 | 0.0 |
| 1 | 4771cc26-131a-45db-b5aa-537ea4ba5342 | 2de017a3-2e01-49cb-a581-08169e83be29 | Fully Paid | 262328 | Short Term | NaN | NaN | 10+ years | Home Mortgage | Debt Consolidation | 33295.98 | 21.1 | 8.0 | 35 | 0 | 229976 | 850784.0 | 0.0 | 0.0 |
| 2 | 4eed4e6a-aa2f-4c91-8651-ce984ee8fb26 | 5efb2b2b-bf11-4dfd-a572-3761a2694725 | Fully Paid | 99999999 | Short Term | 741.0 | 2231892.0 | 8 years | Own Home | Debt Consolidation | 29200.53 | 14.9 | 29.0 | 18 | 1 | 297996 | 750090.0 | 0.0 | 0.0 |
| 3 | 77598f7b-32e7-4e3b-a6e5-06ba0d98fe8a | e777faab-98ae-45af-9a86-7ce5b33b1011 | Fully Paid | 347666 | Long Term | 721.0 | 806949.0 | 3 years | Own Home | Debt Consolidation | 8741.90 | 12.0 | NaN | 9 | 0 | 256329 | 386958.0 | 0.0 | 0.0 |
| 4 | d4062e70-befa-4995-8643-a0de73938182 | 81536ad9-5ccf-4eb8-befb-47a4d608658e | Fully Paid | 176220 | Short Term | NaN | NaN | 5 years | Rent | Debt Consolidation | 20639.70 | 6.1 | NaN | 15 | 0 | 253460 | 427174.0 | 0.0 | 0.0 |
| 5 | 89d8cb0c-e5c2-4f54-b056-48a645c543dd | 4ffe99d3-7f2a-44db-afc1-40943f1f9750 | Charged Off | 206602 | Short Term | 7290.0 | 896857.0 | 10+ years | Home Mortgage | Debt Consolidation | 16367.74 | 17.3 | NaN | 6 | 0 | 215308 | 272448.0 | 0.0 | 0.0 |
| 6 | 273581de-85d8-4332-81a5-19b04ce68666 | 90a75dde-34d5-419c-90dc-1e58b04b3e35 | Fully Paid | 217646 | Short Term | 730.0 | 1184194.0 | < 1 year | Home Mortgage | Debt Consolidation | 10855.08 | 19.6 | 10.0 | 13 | 1 | 122170 | 272052.0 | 1.0 | 0.0 |
| 7 | db0dc6e1-77ee-4826-acca-772f9039e1c7 | 018973c9-e316-4956-b363-67e134fb0931 | Charged Off | 648714 | Long Term | NaN | NaN | < 1 year | Home Mortgage | Buy House | 14806.13 | 8.2 | 8.0 | 15 | 0 | 193306 | 864204.0 | 0.0 | 0.0 |
| 8 | 8af915d9-9e91-44a0-b5a2-564a45c12089 | af534dea-d27e-4fd6-9de8-efaa52a78ec0 | Fully Paid | 548746 | Short Term | 678.0 | 2559110.0 | 2 years | Rent | Debt Consolidation | 18660.28 | 22.6 | 33.0 | 4 | 0 | 437171 | 555038.0 | 0.0 | 0.0 |
| 9 | 0b1c4e3d-bd97-45ce-9622-22732fcdc9a0 | 235c4a43-dadf-483d-aa44-9d6d77ae4583 | Fully Paid | 215952 | Short Term | 739.0 | 1454735.0 | < 1 year | Rent | Debt Consolidation | 39277.75 | 13.9 | NaN | 20 | 0 | 669560 | 1021460.0 | 0.0 | 0.0 |
Last rows
| Loan ID | Customer ID | Loan Status | Current Loan Amount | Term | Credit Score | Annual Income | Years in current job | Home Ownership | Purpose | Monthly Debt | Years of Credit History | Months since last delinquent | Number of Open Accounts | Number of Credit Problems | Current Credit Balance | Maximum Open Credit | Bankruptcies | Tax Liens | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99990 | 686017b3-dc24-4f8a-af92-0bd077452d3d | 1a583add-21ba-410f-9c42-757c4ed19322 | Fully Paid | 99999999 | Short Term | 742.0 | 1190046.0 | < 1 year | Rent | other | 11969.81 | 20.1 | 16.0 | 9 | 0 | 37392 | 134442.0 | 0.0 | 0.0 |
| 99991 | 326d0f2b-015f-480e-90e9-9c0d7d307196 | ed9a397b-8a72-45c2-92de-b91f990a623d | Fully Paid | 244266 | Short Term | 714.0 | 1619047.0 | 10+ years | Rent | Debt Consolidation | 4290.39 | 21.4 | NaN | 5 | 1 | 132012 | 242660.0 | 1.0 | 0.0 |
| 99992 | c568adaa-16f9-43d3-b522-8532fb57cb16 | cbb29fd6-e418-4f09-a4bd-4de83428caab | Fully Paid | 48796 | Short Term | NaN | NaN | 4 years | Home Mortgage | major_purchase | 8298.63 | 8.3 | NaN | 9 | 0 | 87875 | 239404.0 | 0.0 | 0.0 |
| 99993 | 79b81158-5d55-4766-8ad6-ebcd683f7d59 | e45e8dc4-05ad-4efe-92cc-784a6d5ef61a | Fully Paid | 44484 | Short Term | 717.0 | 1152426.0 | 10+ years | Home Mortgage | small_business | 6280.64 | 21.0 | 12.0 | 6 | 0 | 961932 | 0.0 | 0.0 | 0.0 |
| 99994 | 8506a4e9-af7d-47d2-a1bf-7ea2c41858f0 | be67200e-1ef1-4b63-86a6-2bf27d3c704d | Fully Paid | 210584 | Short Term | 719.0 | 783389.0 | 1 year | Home Mortgage | Other | 3727.61 | 17.4 | 18.0 | 6 | 0 | 456 | 259160.0 | 0.0 | 0.0 |
| 99995 | 3f94c18c-ba8f-45d0-8610-88a684a410a9 | 2da51983-cfef-4b8f-a733-5dfaf69e9281 | Fully Paid | 147070 | Short Term | 725.0 | 475437.0 | 7 years | Own Home | other | 2202.86 | 22.3 | NaN | 5 | 0 | 47766 | 658548.0 | 0.0 | 0.0 |
| 99996 | 06eba04f-58fc-424a-b666-ed72aa008900 | 77f2252a-b7d1-4b07-a746-1202a8304290 | Fully Paid | 99999999 | Short Term | 732.0 | 1289416.0 | 1 year | Rent | Debt Consolidation | 13109.05 | 9.4 | 21.0 | 22 | 0 | 153045 | 509234.0 | 0.0 | 0.0 |
| 99997 | e1cb4050-eff5-4bdb-a1b0-aabd3f7eaac7 | 2ced5f10-bd60-4a11-9134-cadce4e7b0a3 | Fully Paid | 103136 | Short Term | 742.0 | 1150545.0 | 6 years | Rent | Debt Consolidation | 7315.57 | 18.8 | 18.0 | 12 | 1 | 109554 | 537548.0 | 1.0 | 0.0 |
| 99998 | 81ab928b-d1a5-4523-9a3c-271ebb01b4fb | 3e45ffda-99fd-4cfc-b8b8-446f4a505f36 | Fully Paid | 530332 | Short Term | 746.0 | 1717524.0 | 9 years | Rent | Debt Consolidation | 9890.07 | 15.0 | NaN | 8 | 0 | 404225 | 738254.0 | 0.0 | 0.0 |
| 99999 | c63916c6-6d46-47a9-949a-51d09af4414f | 1b3014be-5c07-4d41-abe7-44573c375886 | Fully Paid | 99999999 | Short Term | 743.0 | 935180.0 | NaN | Own Home | Debt Consolidation | 9118.10 | 13.0 | NaN | 4 | 1 | 45600 | 91014.0 | 1.0 | 0.0 |
Most frequently occurring
| Loan ID | Customer ID | Loan Status | Current Loan Amount | Term | Credit Score | Annual Income | Years in current job | Home Ownership | Purpose | Monthly Debt | Years of Credit History | Months since last delinquent | Number of Open Accounts | Number of Credit Problems | Current Credit Balance | Maximum Open Credit | Bankruptcies | Tax Liens | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 000bc65a-6a7c-4566-86f3-203b4ec35eca | 724bddb4-a23c-4759-ba6f-dc79c7dd5334 | Fully Paid | 642202 | Short Term | 715.0 | 1759533.0 | 2 years | Rent | Debt Consolidation | 23020.59 | 13.8 | NaN | 11 | 0 | 445987 | 733546.0 | 0.0 | 0.0 | 2 |
| 1 | 000c16df-c24f-41cf-a90e-60301d131bb9 | b07c4262-70bb-41cc-b28a-d87540577fb1 | Fully Paid | 155496 | Short Term | 706.0 | 664753.0 | NaN | Own Home | other | 8087.92 | 21.3 | NaN | 7 | 1 | 79382 | 150700.0 | 1.0 | 0.0 | 2 |
| 2 | 0016d326-7878-46bb-9c18-a75af255d7fe | eccd2965-56cf-4be0-99b2-893f8a520fea | Fully Paid | 88770 | Short Term | 700.0 | 1671221.0 | 2 years | Home Mortgage | Home Improvements | 2562.53 | 10.3 | NaN | 3 | 1 | 67279 | 124234.0 | 1.0 | 0.0 | 2 |
| 3 | 0018f629-8cef-48bd-bb93-40179f24256c | 1e96933c-3a01-46b2-975d-06c5a2b469c3 | Fully Paid | 66396 | Short Term | 711.0 | 535192.0 | 3 years | Rent | Debt Consolidation | 9142.80 | 15.8 | 50.0 | 8 | 0 | 112347 | 307538.0 | 0.0 | 0.0 | 2 |
| 4 | 001a84a9-3fd5-4e82-9153-49325b996408 | b282e6f9-2d09-4988-b579-6d90d104e70d | Fully Paid | 180246 | Long Term | 658.0 | 858097.0 | 2 years | Rent | Other | 10289.83 | 18.4 | 58.0 | 8 | 0 | 288553 | 440220.0 | 0.0 | 0.0 | 2 |
| 5 | 001f3ce7-5277-4202-8511-27b464ea6404 | 96875077-865f-4998-9e93-59b016165fdf | Fully Paid | 65406 | Short Term | 705.0 | 1883090.0 | 3 years | Home Mortgage | Home Improvements | 56021.88 | 23.4 | NaN | 11 | 0 | 408291 | 527648.0 | 0.0 | 0.0 | 2 |
| 6 | 002f3769-888e-4b66-b940-21ec4b7c2c69 | f49f2a18-deba-45de-8af6-e0174b9b4894 | Fully Paid | 142824 | Short Term | 724.0 | 683183.0 | 4 years | Home Mortgage | Debt Consolidation | 11272.51 | 15.4 | NaN | 7 | 0 | 27322 | 77000.0 | 0.0 | 0.0 | 2 |
| 7 | 003665f5-adff-4fbb-903c-14d022fa6a08 | 80c0ee25-ec87-4e1f-aefc-e5bbd679cef1 | Fully Paid | 43692 | Short Term | 719.0 | 679079.0 | 9 years | HaveMortgage | Take a Trip | 8601.68 | 11.0 | 69.0 | 5 | 5 | 16264 | 174328.0 | 1.0 | 4.0 | 2 |
| 8 | 003d60c3-3a4c-4b81-b0f4-3105c34ce2e8 | 9d1e355e-f80d-40a8-b582-d391baa0dce9 | Fully Paid | 194370 | Short Term | 714.0 | 991952.0 | 10+ years | Home Mortgage | other | 11242.11 | 21.0 | 32.0 | 6 | 0 | 168017 | 448272.0 | 0.0 | 0.0 | 2 |
| 9 | 0046bac8-1053-4385-8ffe-93dcebd8ee7d | 4c8dd1fd-1831-4d32-a6e4-cbe4702b2020 | Fully Paid | 515064 | Long Term | 724.0 | 1457851.0 | 8 years | Home Mortgage | Home Improvements | 6900.42 | 28.5 | 49.0 | 11 | 0 | 52288 | 535854.0 | 0.0 | 0.0 | 2 |